USE [Escuela]
GO

/****** Object:  StoredProcedure [dbo].[coop_pago_Get_By_Date]    Script Date: 08/12/2013 21:58:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[coop_pago_Get_By_Date] 
    @month int, 
    @year int,
    @day int,
    @pendiente bit 
AS 
    
SELECT 
[id],
[fecha_pago],
[monto],
[observacion],
[pendiente]
FROM [dbo].[pago] p
WHERE (DATEPART (DD, p.fecha_pago) = @day) AND (DATEPART (MM, p.fecha_pago) = @month) AND (DATEPART (YYYY, p.fecha_pago) = @year) AND (p.pendiente = @pendiente)

GO

